Exploratory Data Analysis

Dataset Overview

Metric Value
Number of Rows 11760
Number of Columns 17
Memory in MB 5.16 MB
Duplicates 0

Missing Values

column missing_count
UserID 0
Taken_product 0
Yearly_avg_view_on_travel_page 581
preferred_device 53
total_likes_on_outstation_checkin_given 381
yearly_avg_Outstation_checkins 75
member_in_family 0
preferred_location_type 31
Yearly_avg_comment_on_travel_page 206
total_likes_on_outofstation_checkin_received 0
week_since_last_outstation_checkin 0
following_company_page 103
montly_avg_comment_on_company_page 0
working_flag 0
travelling_network_rating 0
Adult_flag 0
Daily_Avg_mins_spend_on_traveling_page 0

Numeric Summary

index count mean std min 25% 50% 75% max
UserID 11760.0 1.005880e+06 3394.963917 1000001.0 1002940.75 1005880.5 1008820.25 1011760.0
Yearly_avg_view_on_travel_page 11179.0 2.808308e+02 68.182958 35.0 232.00 271.0 324.00 464.0
total_likes_on_outstation_checkin_given 11379.0 2.817048e+04 14385.032134 3570.0 16380.00 28076.0 40525.00 252430.0
Yearly_avg_comment_on_travel_page 11554.0 7.479003e+01 24.026650 3.0 57.00 75.0 92.00 815.0
total_likes_on_outofstation_checkin_received 11760.0 6.531699e+03 4706.613785 1009.0 2940.75 4948.0 8393.25 20065.0
week_since_last_outstation_checkin 11760.0 3.203571e+00 2.616365 0.0 1.00 3.0 5.00 11.0
montly_avg_comment_on_company_page 11760.0 2.866156e+01 48.660504 11.0 17.00 22.0 27.00 500.0
travelling_network_rating 11760.0 2.712245e+00 1.080887 1.0 2.00 3.0 4.00 4.0
Adult_flag 11760.0 7.938776e-01 0.851823 0.0 0.00 1.0 1.00 3.0
Daily_Avg_mins_spend_on_traveling_page 11760.0 1.381743e+01 9.070657 0.0 8.00 12.0 18.00 270.0

Outliers

{'UserID': 0, 'Yearly_avg_view_on_travel_page': 11, 'total_likes_on_outstation_checkin_given': 4, 'Yearly_avg_comment_on_travel_page': 40, 'total_likes_on_outofstation_checkin_received': 916, 'week_since_last_outstation_checkin': 0, 'montly_avg_comment_on_company_page': 242, 'travelling_network_rating': 0, 'Adult_flag': 680, 'Daily_Avg_mins_spend_on_traveling_page': 350}

Univariate Analysis












Bivariate Analysis